﻿/* dk2Repository - Copyright (C) 2011 Daniel Kuczewski http://www.dk2.de/

 * This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public
License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.
This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Lesser General Public License for more details.
You should have received a copy of the GNU Lesser General Public License along with this library; if not, write to the Free Software
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA */

using System;
using System.Text;

namespace dk2Repository.QueryBuilder.MySql
{
    internal class MySqlInsertBuilder : dk2Repository.QueryBuilder.InsertBuilder
    {
        public MySqlInsertBuilder(ISqlBuilder builder)
            : base(builder)
        {
        }

        public override string CreateSql()
        {
            if (ValueColumns.Length == 0)
                throw new Exception("InsertBuilder must have at least 1 value");

            var sb = new StringBuilder();
            var sb2 = new StringBuilder();

            sb.Append("INSERT INTO ").Append(Table).Append(" (");
            sb2.Append("(");

            foreach (var valueColumn in ValueColumns)
            {
                sb.Append(valueColumn.Column).Append(",");
                sb2.Append(string.IsNullOrEmpty(valueColumn.ParameterName) ? "?" : "@" + valueColumn.ParameterName).Append(",");
            }

            sb.Remove(sb.Length - 1, 1);
            sb.Append(")");
            sb2.Remove(sb2.Length - 1, 1);
            sb2.Append(")");

            sb.Append(" VALUES ").Append(sb2.ToString()).Append(";");

            if (AutoInc)
                sb.Append("Select last_insert_rowid();");

            return sb.ToString();
        }


    }
}